package quary;

public class VinylData {

	public static final String DB = "jdbc:mysql://localhost/vinylklubb";
	public static final String USERNAME = "root";
	public static final String PASSWORD = "kalium123";
	
	public static final String CLUBHOUSE = "klubbhus";
	public static final String CLUBHOUSE_ID = "klubbhus_id";
	public static final String CLUBHOUSE_NAME = "navn";
	public static final String CLUBHOUSE_ADDRESS = "adresse";
	public static final String CLUBHOUSE_ZIP = "postnummer";
	public static final String CLUBHOUSE_PHONE = "telefon";
	
	public static final String MEMBER = "medlem";
	public static final String MEMBER_ID = "medlem_id";
	public static final String MEMBER_PERSON_ID = "person_id";
	public static final String MEMBER_REG_DATE = "registrerings_dato";
	public static final String MEMBER_POSITION = "stilling";
	
	public static final String PERSON = "person";
	public static final String PERSON_ID = "person_id";
	public static final String PERSON_FIRST_NAME = "fornavn";
	public static final String PERSON_MIDDLE_NAME = "mellomnavn";
	public static final String PERSON_LAST_NAME = "etternavn";
	public static final String PERSON_ADDRESS = "adresse";
	public static final String PERSON_ZIP = "postnummer";
	public static final String PERSON_LOCATION = "sted";
	public static final String PERSON_PHONE = "telefon";
	public static final String PERSON_EMAIL = "epost";
	
	public static final String STORAGE = "plassering";
	public static final String STORAGE_ID = "plass_id";
	public static final String STORAGE_IN_CLUBHOUSE = "i_klubbhus";
	public static final String STORAGE_AT_MEMBER = "hos_medlem";
	public static final String STORAGE_DESCRIPTION = "beskrivelse";
	
	public static final String ACCESS = "tilgang";
	public static final String ACCESS_MEMBER_ID = "medlem_id";
	public static final String ACCESS_STORAGE_ID = "plass_id";
	
	public static final String LOANS = "utlaan";
	public static final String LOANS_VINYL_ID = "vinyl_id";
	public static final String LOANS_MEMBER_ID = "medlem_id";
	public static final String LOANS_LOAN_DATE = "laans_dato";
	public static final String LOANS_DELIVERY_DATE = "leverings_dato";

	public static final String VINYL = "vinyl";
	public static final String VINYL_ID = "vinyl_id";
	public static final String VINYL_ARTIST = "artist";
	public static final String VINYL_ALBUM = "album";
	public static final String VINYL_MUSIC_STYLE = "musikk_stil";
	public static final String VINYL_FORMAT = "format";
	public static final String VINYL_LABEL = "plateselskap";
	public static final String VINYL_OWNER = "eier";
	public static final String VINYL_DELIVERY_DATE = "levers_til_eier";
	public static final String VINYL_STORAGE = "plassering";
}
